Improving the Data Warehouse Architecture Using Design Patterns
نویسندگان
چکیده
Data warehousing is an important part of the enterprise information system. Business intelligence (BI) relies on data warehouses to improve business performance. Data quality plays a key role in BI. Source data is extracted, transformed, and loaded (ETL) into the data warehouses periodically. The ETL operations have the most crucial impact on the data quality of the data warehouse. ETL-related data warehouse architectures including structure-oriented layer architectures and enterpriseview data mart architecture were studied in the literature. Existing architectures have the layer and data mart components but do not make use of design patterns; thus, those approaches are inefficient and pose potential problems. This paper relays how to use design patterns to improve data warehouse architectures.
منابع مشابه
Improvement of the Analytical Queries Response Time in Real-Time Data Warehouse using Materialized Views Concatenation
A real-time data warehouse is a collection of recent and hierarchical data that is used for managers’ decision-making by creating online analytical queries. The volume of data collected from data sources and entered into the real-time data warehouse is constantly increasing. Moreover, as the volume of input data to the real time data warehouse increases, the interference between online loading ...
متن کاملImpact of Airflow on Moderating Thermal Conditions in Vernacular Houses; Case Study: Bandar-e Lengeh Houses in Hot and Humid Climate of Iran
As an example of extreme hot humid climate, the southern marginal rim of Iran is a perfect candidate for studying climatic patterns. Attention to climatic components in housing design process within this area is therefore essential. Benefitting from the airflow and avoiding heat and radiation are among the most effective approaches towards moderating heat conditions in hot and humid areas. ...
متن کاملExploring Model Driven Architecture Approach to Design Star Schema for a Data Warehouse
Data Integration Technologies have experienced explosive growth in the last few years, and data warehousing has played a major role in this context. This has become one of the most important applications of database technology today. A large number of data warehousing methodologies and tools are available to support the growing market needs but it is generally agreed that warehouse design is a ...
متن کاملAcm Tech Pack on Business Intelligence/data Management Bi/dm Tech Pack Committee
The increasing search for computational solutions to support the decisionmaking led to the development of new technologies that aim to transform the large volume of data in information and knowledge useful. The data warehousing technology emerged with the aim of structuring the data in the best way possible to facilitate its access, making the process more efficient and effective. Along with it...
متن کاملThe Concept of Behavioral Setting and its Impact on Improving Environmental Quality Neighborhood Parks (Case Study: Shiraz SEKONJ Neighborhood Park)
Neighborhood parks are important as spaces of residential neighborhoods where part of the daily interactions of residents take place. Hence, the study of environmental quality of the behavioral settings in which they are formed can be considered a suitable indicator to measure environmental quality with behavioral patterns. In order to intervene or adopt strategies in the design and planning of...
متن کامل